import pandas as pd

file = "path.csv"
filedata = pd.read_csv(file)
temp = filedata.loc[0]

Names = []
Items = []
Items.append(temp)
Names.append(temp["Product_Name"])

for i in range(1,len(filedata)):
    item = filedata.loc[i]
    name = item["Product_Name"]
    
    if name not in Names:
        Items.append(item)
        Names.append(name)
    
I = pd.DataFrame(Items)
I.to_csv('Items_Info.csv',index = False)    

